Ebix 2nd round interview
1. Tell about your self 
2.what is index . types and when you used index
3. What is trigger and types 
4.exception and types
5.how to alter the sequence value 10000 to 5000 (reduce)
6.what is pragma autonomous transaction ..and where it is used 
7. How to find the error in SQL and plsql 
8. Table A having 10 records , table B having 6 records .. I am insert 4 records in Table A then truncating table B ...now insert 3 records in Table A ...then insert 5 records in table B  now I am going to do ROLLBACK table A and Table B records ?
9. What is function and its types 
10. Employees table having column Emp_I'd ,Dept_I'd,Dept_name,
salary....
    Department table having column is Dept_I'd,name
Write a query for above two tables 
(1). Create syntax for this two tables
(2). Find the duplicate records in employees table based on department table
(3). Select highest salary for each department ..